package com.deepinjava.dbbmlite

class OracleProvider : BaseSqlProvider() {
    override val sysTimestamp = "SYSTIMESTAMP"
    protected override val readPage = "OFFSET #offset ROWS FETCH NEXT #pagesize ROWS ONLY"
    protected override val readTop = "FETCH FIRST ? ROWS ONLY"
    protected override val instrLoc = "INSTR(SCOL,'#1#1#1#1')"

    override val defINT = "NUMBER"
    override val defBIGINT = "NUMBER"
    override val defDOUBLE = "FLOAT"
    override val defDATETIME = "TIMESTAMP"

    override fun getSumSql(i: Int): String {
        return super.getSumSql(i).replace("SUBSTRING", "SUBSTR",ignoreCase = true)
    }
}